﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// Summary description for languageDAL
/// </summary>
public class languageDAL
{
    DataAccess da = new DataAccess();
	public languageDAL()
	{

		//
		// TODO: Add constructor logic here
		//
	}
    public DataTable getLanguageByID(int language_id)
    {
        SqlParameter[] param = new SqlParameter[1];
        param[0] = da.AddParameter("language_id", language_id, SqlDbType.Int, null);
        return da.executeSelect("GET_LANGUAGE", param);
    }
    public DataTable getAllLanguage()
    {
        SqlParameter[] param = new SqlParameter[1];
        param[0] = da.AddParameter("language_id", DBNull.Value, SqlDbType.Int, null);
        return da.executeSelect("GET_LANGUAGE", param);
    }
    
}